﻿create procedure [dbo].usp_AddEmployeeLeave
@EmpId as int,
@LeaveDate as datetime,
@LeaveType as nvarchar(10),
@AM as bit,
@PM as bit

as

insert into TblEmployeeLeaves(EmpId,Leave,LeaveType,AM,PM)
values (@EmpId,@LeaveDate, @LeaveType, @AM, @PM)